/**
 *    Copyright ${license.git.copyrightYears} the original author or authors.
 *
 *    Licensed under the Apache License, Version 2.0 (the "License");
 *    you may not use this file except in compliance with the License.
 *    You may obtain a copy of the License at
 *
 *       http://www.apache.org/licenses/LICENSE-2.0
 *
 *    Unless required by applicable law or agreed to in writing, software
 *    distributed under the License is distributed on an "AS IS" BASIS,
 *    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *    See the License for the specific language governing permissions and
 *    limitations under the License.
 */
package org.mybatis.generator.codegen.ibatis2.sqlmap.elements;

import static org.mybatis.generator.internal.util.StringUtility.stringHasValue;

import org.mybatis.generator.api.IntrospectedColumn;
import org.mybatis.generator.api.dom.xml.Attribute;
import org.mybatis.generator.api.dom.xml.TextElement;
import org.mybatis.generator.api.dom.xml.XmlElement;

/**
 * 
 * @author Jeff Butler
 * 
 */
public class ExampleWhereClauseElementGenerator extends AbstractXmlElementGenerator {

  public ExampleWhereClauseElementGenerator() {
    super();
  }

  @Override
  public void addElements(XmlElement parentElement) {
    XmlElement answer = new XmlElement("sql"); //$NON-NLS-1$

    answer.addAttribute(new Attribute("id", introspectedTable.getExampleWhereClauseId())); //$NON-NLS-1$

    context.getCommentGenerator().addComment(answer);

    XmlElement outerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
    outerIterateElement.addAttribute(new Attribute("property", "oredCriteria")); //$NON-NLS-1$ //$NON-NLS-2$
    outerIterateElement.addAttribute(new Attribute("conjunction", "or")); //$NON-NLS-1$ //$NON-NLS-2$
    outerIterateElement.addAttribute(new Attribute("prepend", "where")); //$NON-NLS-1$ //$NON-NLS-2$
    outerIterateElement.addAttribute(new Attribute("removeFirstPrepend", "iterate")); //$NON-NLS-1$ //$NON-NLS-2$
    answer.addElement(outerIterateElement);

    XmlElement isEqualElement = new XmlElement("isEqual"); //$NON-NLS-1$
    isEqualElement.addAttribute(new Attribute("property", "oredCriteria[].valid")); //$NON-NLS-1$ //$NON-NLS-2$
    isEqualElement.addAttribute(new Attribute("compareValue", "true")); //$NON-NLS-1$ //$NON-NLS-2$
    outerIterateElement.addElement(isEqualElement);

    isEqualElement.addElement(new TextElement("(")); //$NON-NLS-1$

    XmlElement innerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
    innerIterateElement.addAttribute(new Attribute("prepend", "and")); //$NON-NLS-1$ //$NON-NLS-2$
    innerIterateElement.addAttribute(new Attribute("property", "oredCriteria[].criteriaWithoutValue")); //$NON-NLS-1$ //$NON-NLS-2$
    innerIterateElement.addAttribute(new Attribute("conjunction", "and")); //$NON-NLS-1$ //$NON-NLS-2$
    innerIterateElement.addElement(new TextElement("$oredCriteria[].criteriaWithoutValue[]$")); //$NON-NLS-1$
    isEqualElement.addElement(innerIterateElement);

    innerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
    innerIterateElement.addAttribute(new Attribute("prepend", "and")); //$NON-NLS-1$ //$NON-NLS-2$
    innerIterateElement.addAttribute(new Attribute("property", "oredCriteria[].criteriaWithSingleValue")); //$NON-NLS-1$ //$NON-NLS-2$
    innerIterateElement.addAttribute(new Attribute("conjunction", "and")); //$NON-NLS-1$ //$NON-NLS-2$
    innerIterateElement.addElement(new TextElement(
        "$oredCriteria[].criteriaWithSingleValue[].condition$ #oredCriteria[].criteriaWithSingleValue[].value#")); //$NON-NLS-1$
    isEqualElement.addElement(innerIterateElement);

    innerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
    innerIterateElement.addAttribute(new Attribute("prepend", "and")); //$NON-NLS-1$ //$NON-NLS-2$
    innerIterateElement.addAttribute(new Attribute("property", "oredCriteria[].criteriaWithListValue")); //$NON-NLS-1$ //$NON-NLS-2$
    innerIterateElement.addAttribute(new Attribute("conjunction", "and")); //$NON-NLS-1$ //$NON-NLS-2$
    innerIterateElement.addElement(new TextElement("$oredCriteria[].criteriaWithListValue[].condition$")); //$NON-NLS-1$
    XmlElement innerInnerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
    innerInnerIterateElement.addAttribute(new Attribute("property", //$NON-NLS-1$
        "oredCriteria[].criteriaWithListValue[].values")); //$NON-NLS-1$
    innerInnerIterateElement.addAttribute(new Attribute("open", "(")); //$NON-NLS-1$ //$NON-NLS-2$
    innerInnerIterateElement.addAttribute(new Attribute("close", ")")); //$NON-NLS-1$ //$NON-NLS-2$
    innerInnerIterateElement.addAttribute(new Attribute("conjunction", ",")); //$NON-NLS-1$ //$NON-NLS-2$
    innerInnerIterateElement.addElement(new TextElement("#oredCriteria[].criteriaWithListValue[].values[]#")); //$NON-NLS-1$
    innerIterateElement.addElement(innerInnerIterateElement);
    isEqualElement.addElement(innerIterateElement);

    innerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
    innerIterateElement.addAttribute(new Attribute("prepend", "and")); //$NON-NLS-1$ //$NON-NLS-2$
    innerIterateElement.addAttribute(new Attribute("property", "oredCriteria[].criteriaWithBetweenValue")); //$NON-NLS-1$ //$NON-NLS-2$
    innerIterateElement.addAttribute(new Attribute("conjunction", "and")); //$NON-NLS-1$ //$NON-NLS-2$
    innerIterateElement.addElement(new TextElement("$oredCriteria[].criteriaWithBetweenValue[].condition$")); //$NON-NLS-1$
    innerIterateElement.addElement(new TextElement("#oredCriteria[].criteriaWithBetweenValue[].values[0]# and")); //$NON-NLS-1$
    innerIterateElement.addElement(new TextElement("#oredCriteria[].criteriaWithBetweenValue[].values[1]#")); //$NON-NLS-1$
    isEqualElement.addElement(innerIterateElement);

    // if any of the columns have a user defined type handler, then we need
    // to add additional inner iterate elements that specify the type
    // handler
    for (IntrospectedColumn introspectedColumn : introspectedTable.getNonBLOBColumns()) {
      if (stringHasValue(introspectedColumn.getTypeHandler())) {
        // name the property based on the column name, then
        // add the type handler to the parameter declaration
        StringBuilder sb1 = new StringBuilder();
        StringBuilder sb2 = new StringBuilder();
        innerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
        innerIterateElement.addAttribute(new Attribute("prepend", "and")); //$NON-NLS-1$ //$NON-NLS-2$

        sb1.append("oredCriteria[]."); //$NON-NLS-1$
        sb1.append(introspectedColumn.getJavaProperty());
        sb1.append("CriteriaWithSingleValue"); //$NON-NLS-1$

        innerIterateElement.addAttribute(new Attribute("property", sb1.toString())); //$NON-NLS-1$
        innerIterateElement.addAttribute(new Attribute("conjunction", "and")); //$NON-NLS-1$ //$NON-NLS-2$

        sb2.append(sb1);

        sb1.insert(0, '$');
        sb1.append("[].condition$ ");//$NON-NLS-1$

        sb2.insert(0, '#');
        sb2.append("[].value,handler=");//$NON-NLS-1$
        sb2.append(introspectedColumn.getTypeHandler());
        sb2.append('#');

        sb1.append(sb2);

        innerIterateElement.addElement(new TextElement(sb1.toString()));
        isEqualElement.addElement(innerIterateElement);

        sb1.setLength(0);
        sb2.setLength(0);
        sb1.append("oredCriteria[]."); //$NON-NLS-1$
        sb1.append(introspectedColumn.getJavaProperty());
        sb1.append("CriteriaWithListValue"); //$NON-NLS-1$

        innerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
        innerIterateElement.addAttribute(new Attribute("prepend", "and")); //$NON-NLS-1$ //$NON-NLS-2$
        innerIterateElement.addAttribute(new Attribute("property", sb1.toString())); //$NON-NLS-1$
        innerIterateElement.addAttribute(new Attribute("conjunction", "and")); //$NON-NLS-1$ //$NON-NLS-2$

        sb2.append('$');
        sb2.append(sb1);
        sb2.append("[].condition$"); //$NON-NLS-1$

        innerIterateElement.addElement(new TextElement(sb2.toString()));

        sb2.setLength(0);
        sb2.append(sb1);
        sb2.append("[].values"); //$NON-NLS-1$

        innerInnerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
        innerInnerIterateElement.addAttribute(new Attribute("property", //$NON-NLS-1$
            sb2.toString()));
        innerInnerIterateElement.addAttribute(new Attribute("open", "(")); //$NON-NLS-1$ //$NON-NLS-2$
        innerInnerIterateElement.addAttribute(new Attribute("close", ")")); //$NON-NLS-1$ //$NON-NLS-2$
        innerInnerIterateElement.addAttribute(new Attribute("conjunction", ",")); //$NON-NLS-1$ //$NON-NLS-2$

        sb2.setLength(0);
        sb2.append('#');
        sb2.append(sb1);
        sb2.append("[].values[],handler="); //$NON-NLS-1$
        sb2.append(introspectedColumn.getTypeHandler());
        sb2.append('#');

        innerInnerIterateElement.addElement(new TextElement(sb2.toString()));
        innerIterateElement.addElement(innerInnerIterateElement);
        isEqualElement.addElement(innerIterateElement);

        sb1.setLength(0);
        sb2.setLength(0);
        sb1.append("oredCriteria[]."); //$NON-NLS-1$
        sb1.append(introspectedColumn.getJavaProperty());
        sb1.append("CriteriaWithBetweenValue"); //$NON-NLS-1$

        innerIterateElement = new XmlElement("iterate"); //$NON-NLS-1$
        innerIterateElement.addAttribute(new Attribute("prepend", "and")); //$NON-NLS-1$ //$NON-NLS-2$
        innerIterateElement.addAttribute(new Attribute("property", sb1.toString())); //$NON-NLS-1$
        innerIterateElement.addAttribute(new Attribute("conjunction", "and")); //$NON-NLS-1$ //$NON-NLS-2$

        sb2.append('$');
        sb2.append(sb1);
        sb2.append("[].condition$"); //$NON-NLS-1$

        innerIterateElement.addElement(new TextElement(sb2.toString()));

        sb2.setLength(0);
        sb2.append(sb1);

        sb1.insert(0, '#');
        sb1.append("[].values[0],handler="); //$NON-NLS-1$
        sb1.append(introspectedColumn.getTypeHandler());
        sb1.append("# and"); //$NON-NLS-1$

        sb2.insert(0, '#');
        sb2.append("[].values[1],handler="); //$NON-NLS-1$
        sb2.append(introspectedColumn.getTypeHandler());
        sb2.append('#');

        innerIterateElement.addElement(new TextElement(sb1.toString()));
        innerIterateElement.addElement(new TextElement(sb2.toString()));
        isEqualElement.addElement(innerIterateElement);
      }
    }

    isEqualElement.addElement(new TextElement(")")); //$NON-NLS-1$

    if (context.getPlugins().sqlMapExampleWhereClauseElementGenerated(answer, introspectedTable)) {
      parentElement.addElement(answer);
    }
  }
}
